/****** Object:  Table [EventNotification].[EnrollmentNotificationEvents]    Script Date: 03/15/2012 23:37:10 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [EnrollmentNotificationEvents](
	[EventID] [int] IDENTITY(1,1) NOT NULL,
	[EventService] [nvarchar](25) NOT NULL,
	[EventStatus] [int] NULL,
	[RecipientName] [nvarchar](50) NULL,
	[RecipientAddress] [nvarchar](100) NULL,
	[Recipient2] [nvarchar](100) NULL,
	[RecipientAddress2] [nvarchar](200) NULL,
	[CreatedAt] [datetime] NULL,
	[DateNotified] [datetime] NULL,
	[FirstName] [nvarchar](50) NULL,
	[LastName] [nvarchar](50) NULL,
	[SurveyName] [nvarchar](100) NULL,
	[SurveyID] [nvarchar](50) NULL,
	[SponsorName] [nvarchar](100) NULL,
	[OtherField] [nvarchar](100) NULL,
PRIMARY KEY CLUSTERED 
(
	[EventID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]